https://store-images.s-microsoft.com/image/apps.41581.ac57c65b-903c-4731-bcd7-826a699c2277.c7016a6d-5772-451b-b561-e5479a3dc5b6.3cca01ce-2190-4712-8411-ae979c16fef7

JetCube GL Detail API Queries

durch JET CUBE INC

Extend financial reporting with enhanced API Query access to General Ledger (GL) Entries.

Unlock richer financial insights in Dynamics 365 Business Central. This extension adds 3 new API queries based on the General Ledger Entries table, exposing additional fields such as vendor name, customer name, and shortcut dimension codes, essential for advanced financial reporting and integration scenarios. It also introduces a calculated field that converts posting dates into a standardized posting period format yyyyMM, simplifying period-based analysis and reporting. Whether you're building dashboards, syncing data with external systems, or just need more granular visibility, this app gives you the tools to do it faster and smarter.


The 3 new API queries can be seen in the screenshots below. The Fields highlighted in yellow are usually the fields needed for financial reporting while all the non-highlighted fields are also included and are useful when drilling down into the details.


These 3 new API queries also make it easier to import, drill-down and create Business Central financial income statement and balance sheet reports using software like Excel, Power BI or our very own JetCube Financial Reporting, Forecasting and Budgeting.

Auf einen Blick

https://store-images.s-microsoft.com/image/apps.9778.ac57c65b-903c-4731-bcd7-826a699c2277.c7016a6d-5772-451b-b561-e5479a3dc5b6.a8b18948-b626-4638-b9a8-95ef76def1c5
https://store-images.s-microsoft.com/image/apps.38678.ac57c65b-903c-4731-bcd7-826a699c2277.c7016a6d-5772-451b-b561-e5479a3dc5b6.ee56330a-fac3-46d1-80c1-e82629cf7b4d
https://store-images.s-microsoft.com/image/apps.14760.ac57c65b-903c-4731-bcd7-826a699c2277.c7016a6d-5772-451b-b561-e5479a3dc5b6.7c2a7b05-14a3-44be-a442-9459dd3eabb2
https://store-images.s-microsoft.com/image/apps.26601.ac57c65b-903c-4731-bcd7-826a699c2277.c7016a6d-5772-451b-b561-e5479a3dc5b6.2d84d6e3-5a2d-4093-9126-9ceefcf9a01b
https://store-images.s-microsoft.com/image/apps.59208.ac57c65b-903c-4731-bcd7-826a699c2277.c7016a6d-5772-451b-b561-e5479a3dc5b6.032ed1fc-2cf0-45a0-b6b6-4a1cd301ec44